NoSQL operator: tabletolist

Converts from NoSQL 'table' to 'list' format.

Usage: tabletolist [options] [table table ...]

Options:
    --input (-i) 'file'
      Read input from 'file' instead of STDIN.

    --output (-o) 'file'
      Write output to 'file' instead of STDOUT.

    --help (-h)
      Display this help text.

    --prefix (-p) 'string'
      Prefix each default output column name with 'string'.

    --separator (-s) 'string'
      Use 'string' to separate column names from column values
      on output, as opposed to the default TAB character. If this
      option is specified it overrides '-j'.

    --trim (-t)
      Strip surrounding blanks from variable values.

    --no-header (-N)
      Do not print the leading newline. Used to produce a list
      that is to be appended to another.

    --no-footer (-F)
      Do not print the trailing newline. Used to produce a list
      that can be appended to.

    --chop (-C)
      Deprecated option, use '-N' instead.

    --chomp (-c)
      Deprecated option, use '-F' instead.

    --no-unescape (-n)
      Do not unescape '\t' and '\n' sequences that may be present
      in the data.

    --mux (-m)
      The output stream will be in 'muxed' format, suitable to
      be fed into 'muxtotable. This option is ignored if '-n'
      is also specified.

    --justify (-j)
      Align output as needed to make it look nicer. Note that the
      output stream will not be a valid NoSQL list anymore. If this
      option is specified it overrides '-s'.

    --no-empty (-e)
      Do not print empty fields on output. Note that this will
      produce an invalid list, although it may be ok if '-m'
      was also requested.

    --unique (-u)
      Do not print duplicated column names on output.

    --ldif (-l)
      Produce output in LDAP's LDIF format.
      Implies the following options:  -e -s ": " -N -F -u
      Clears the following options: '-j' and '-m'

    --lists (-L)
      If any of the input fields contain valid rc(1) lists, the
      relevant embedded "\001" separators are turned into either
      phisical newlines, or escaped newlines (\\n) if '-n' was also
      specified.

Notes:

If multiple IFS-separated table names are listed on the command line,
they are converted in one single output list all in one go, even if they
contain a different number of columns, possibly with different column
names. This can sometimes be useful to feed data from multiple tables
into 'muxtotable'. If an input file is specified through option '-i' it
will simply be prepended to the list of input files.
Back